﻿CREATE TABLE [acms].[Users]
(
	Id int NOT NULL Identity(1,1), 
	FirstName varchar(50),
	LastName varchar(50),
	UserName varchar(50),
	Salt int,
	Password varchar(255),
	DateOfBirth DateTime,
	EmailAddress varchar(100),
	PasswordQuestion varchar(255),
	PasswordAnswer varchar(255),
	Authenticated bit default(0),
	Created DateTime default(getdate()),
	Locked bit default(0),
	LastLogin datetime,
	LastActivity datetime,
	LastChangedPassword	datetime,
	LastLocked datetime,
	Deleted bit default(0),
	ConcurencyId RowVersion
);
